Global Group Properties

The name of the CSV file created.

The name of each report must be unique, or the reports overwrite each other.

The Microsoft Excel workbook which is opened with the report CSV file and controls the presentation of the report data.

The template can be an XLS or an XLSX file. You can use the same template for multiple reports.

A Microsoft Excel template is created by MineSched, with the name specified in the Excel template field and an XLS file extension.

Notes:

• The CSV report must exist before you can create the template. If you click Create template and the CSV file has not been created, a warning appears.
• If you click Create template and have specified, in the Excel template field, the name of an XLS file that exists, the existing file is overwritten.
• If a file of the name specified in the Excel template field does not exist, the template file is created when you create the report, even if you do not click Create template.

The type of report you want to create. Options are:

• Summary: The report provides totals for each scheduling period. Summary is the most commonly used report type.
• Detailed: The report provides detailed information, the mining method determines the type of information contained in the report. If the mining method is benches, detailed reports contain data for every bench. If the mining method is Polygons or Bench Polygons, detailed reports contain data for every polygon. If the mining method is Solids, detailed reports contain data for every object.
• Location: The report provides information on the mining that occurs at each location in each period.
• Bench: Similar to the Detailed report, the Bench report provides data for each elevation at each location over the scheduling periods. The difference between Bench and Detailed reports is that the information in a Bench report is for only one report code for each report group.

The method by which the periods are reported. Options are:

• Row: Period data is written in successive rows in the report. The Report definition section aligns the options you can select for each report group in rows.
• Column: Period data is written in successive columns in the report. The Report definition section aligns the options you can select for each report group in columns.

Note: You can choose to create Summary, Detailed, and Location reports as column-based or row-based. However, detailed reports can produce many rows or columns of data output for each period. Microsoft Excel 2003 has a limit of 256 columns, and Excel 2007 and later has a limit of 16 384 columns. If you think your report will exceed the column limit for your version of Excel, choose a row-based report.

• Selected: The grand total of all periods is reported at the end of each column or row of the report. If Periods by is Row, the total is at the end of each column. If Periods by is Column, the total is at the end of each row.
• Cleared: The grand total for each period is not reported.

Note: Grand totals are available only if the report type is Summary.

The title style used in the report. Options are:

• Automatic titles: A single-line title, of the format "<Value> of <Material> <removed from/added to/balance> on <Location>" is used in the report. The values selected in the Filtering section of the Report definition are used to create the title for each row or column automatically.
• Custom titles: The entries you type in the Titles section of the Report definition define the titles.

The number of title lines.

The number of lines defined here controls the number of lines that appear in the Titles section of the Report definition, in which you can type values for the title.

Opens the Report Options form, which you use to define the report layout options.

Fields on the Report Options Form